Stored Procedures [dbo].[BAEImisNameGetAllByMemberType]
SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEImisNameGetAllByMemberType
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@memberTypevarchar(5)5
SQL Script
create procedure [dbo].[BAEImisNameGetAllByMemberType] @memberType varchar(5) as
SELECT ID
    FROM Name
    WHERE MEMBER_TYPE = @memberType

GO
Uses
Created 05 April 2012 11:11
Copyright  2012 - All Rights Reserved